<?php
set_time_limit(0);

mysql_connect("localhost","root","");
mysql_select_db("diandi_danci");
mysql_query("set names utf8");
$result = mysql_query("select *from word");
while($row =mysql_fetch_array($result)){
	if($row['symbol0'])
	mysql_query("insert into pronunciation (symbol,`type`,word_id) value(\"".mysql_escape_string($row['symbol0'])."\",0,".$row['id'].")");
	if($row['symbolA'])
	mysql_query("insert into pronunciation (symbol,`type`,word_id) value(\"".mysql_escape_string($row['symbolA'])."\",2,".$row['id'].")");
	if($row['symbolE'])
	mysql_query("insert into pronunciation (symbol,`type`,word_id) value(\"".mysql_escape_string($row['symbolE'])."\",1,".$row['id'].")");
}